Welcome
Guest
, you are in:
<root>
•
Login
devio dbscript ScrewTurn Wiki
Navigation
¶
Main Page
Random Page
Create a new Page
All Pages
Categories
Navigation Paths
Administration
File Management
Create Account
Search the wiki
»
Discuss (0)
View Page Code
History
HR COUNTRIES (table)
Print
RSS
Modified on 2011/08/27 12:09
by
wikibot
Categorized as
Uncategorized
HR LOCATIONS (table)
HR REGIONS (table)
HR LOCATIONS (table)
HR REGIONS (table)
»
HR COUNTRIES (table)
[X]
»
HR COUNTRIES (table)
wikibot
¶
Table
HR.COUNTRIES
Description
country table. Contains 25 rows. References with locations table.
Columns
¶
Column
Data Type
Nullable
Default
Description
COUNTRY_ID
CHAR(2)
not null
Primary key of countries table.
COUNTRY_NAME
VARCHAR2(40)
null
Country name
REGION_ID
NUMBER
null
Region ID for the country. Foreign key to region_id column in the departments table.
Primary Key
¶
Primary Key
Columns
COUNTRY_C_ID_PK
COUNTRY_ID
Check Constraints
¶
Check Constraint
Expression
Description
COUNTRY_ID_NN
"COUNTRY_ID" IS NOT NULL
Foreign Keys
¶
Relation
Column
Referenced Column
HR.REGIONS
REGION_ID
REGION_ID
Detail Tables
¶
Detail Table
Column
Referencing Column
HR.LOCATIONS
COUNTRY_ID
COUNTRY_ID
ScrewTurn Wiki
version 3.0.1.400. Some of the icons created by
FamFamFam
.